Skip to main content
This forum is closed to new posts and responses. Individual names altered for privacy purposes. The information contained in this website is provided for informational purposes only and should not be construed as a forum for customer support requests. Any customer support requests should be directed to the official HCL customer support channels below:

HCL Software Customer Support Portal for U.S. Federal Government clients
HCL Software Customer Support Portal

Notes/Domino 6 and 7 Forum

Notes/Domino 6 and 7 Forum


  

PreviousPrevious NextNext


~Evelyn Lopponemanjip 5.Nov.03 04:33 PM a Web browser
Domino Server 6.5; 6.0.1 CF1 Windows XP


I have a two agents that suffer the same problem and it's starting to drive me mad!

The agents run server-side, are both written in formula and they both consist of a SELECT and a field assignment (FIELD := x).

One of the agents has the following code:

SELECT Form = "frmConfig" & Enabled = "Enabled" & Status *= "Pending":"Complete" &
((RunNextDateTime = "") | (RunNextDateTime < @Now));
FIELD Status := "Queued";

When the agent is set to run against *all documents* in the database it runs without warning. Not very efficient IMHO as it's scanning every document in the database (over 10,000 of them) to determine which ones to process.

When the agent is set to run with a search criteria, and that search criteria is "In folder '(Configs)'", the agent gives the warning (in the server log):

"Warning: Agent is performing full text operations on database 'testdb.nsf' which is not full text indexed. This is extremely inefficient."

The view's formula is nothing special - just a "SELECT Form = 'frmConfig'" - i.e., it just narrows the search from over 10,000 docs to around 8. Correct me if I'm wrong but I don't understand why using a view to narrow the scope of an agent is "extremely inefficient". It doesn't add up.

Does anyone have any idea what the point of this warning is, whether I've missed something obvious, and how to stop it? I don't want to FT index the database because apart from this warning there's no reason to.

Many thanks in advance for any ideas!

- Phil






Warning: Agent is performing full t... (~Evelyn Loppone... 5.Nov.03)
. . RE: Warning: Agent is performing fu... (~Autumn Kijipym... 5.Nov.03)
. . . . RE: Warning: Agent is performing fu... (~Evelyn Loppone... 5.Nov.03)





  Document options
Print this pagePrint this page

 Search this forum

  Forum views and search
Date (threaded)
Date (flat)
With excerpt
Category
Platform
Release
Advanced search

 RSS feedsRSS
All forum posts RSS
All main topics RSS